Mid-Level Data Analyst

Job description and responsibilities

Role Responsibilities

Work in close collaboration with the Business Intelligence Lead, Federal Data Lead and other Program teams

Develop, maintain, and improve BI tools, build and enhance standard operating procedures (SOPs)

Manage various data sets and active Google workbooks with adjacent contract teams, monitor and analyze financial health information at the project and program levels

Communicate with client leadership to assess data needs and emerging requirements

Lead Tableau projects for the BI team - will be responsible for developing new (custom) dashboards, maintaining and enhancing existing tools, and driving the adoption and growth of dashboard-based data consumption throughout the organization.

Work with large data sets, workbooks and spreadsheets to manipulate and manage program-level information using macros, queries, scripts, etc.

Gather requirements and lead development of long-term data management tools, processes and solutions based on organizational needs.

Be comfortable working with collaboration tools such as; Google Suite, Microsoft Office

Providing general support to the client including, but not limited to, analysis, data calls, financial management, risk management, audits, and project management related tasks.

Requirements and qualifications:

Qualifications

Bachelor's Degree in business, business intelligence, data or information management, or similar.

Proficient in Google Scripts

Minimum 2 years of data or information management and/or data analysis experience.

Minimum 2 years of experience working with data visualization tools (Tableau/Power BI, ideally focused in developing custom dashboards).

Experience using Microsoft Excel and Google Sheets (macros, imports, query functions).

Experience with developing in Google App Script is a plus.

Experience using SQL Developer is a plus.

Excellent written and verbal communication skills.

Consulting / client management experience recommended.

Willing to work in an administratively manual environment while working towards automation of processes in the future.

Clearable (able to pass both a criminal background check and credit check